The Unkissed Bride

The Unkissed Bride is a 1966 comedy starring Tommy Kirk. The film is also known as Mother GooseAGoGo.

Nervous about the prospect of having sex, Margie picks up a copy of Mother Goose and begins reading from it, causing Ted to faint.Dr. Richards DHondt, a psychiatrist, deduces that Ted has a Mother Goose complex and treats him with an LSD spray while he sleeps. This causes him to hallucinate and mix up reality with fairy tales. ........

Source: Wikipedia